ATTO550: home page, spectra in xls
ATTO647N: home page, spectra in xls
In [1]:
atto550_ext_coeff = 1.2*1e5 # 1 / ( mol cm )
atto647N_ext_coeff = 1.5*1e5 # 1 / ( mol cm )
In [2]:
%matplotlib inline
import matplotlib.pyplot as plt
import pandas as pd
In [3]:
a550 = pd.read_excel('ATTO550.xlsx', 'Tabelle1', index_col=None, na_values=['NA'])
a647N = pd.read_excel('ATTO647N.xlsx', 'Tabelle1', index_col=None, na_values=['NA'])
In [4]:
a550[:4]
Out[4]:
In [5]:
a647N[:4]
Out[5]:
In [6]:
a550.columns = ['wl_absorption', 'absorption', 'none', 'wl_emission', 'emission']
ab_550 = a550[['wl_absorption', 'absorption']][2:].set_index('wl_absorption').dropna()
em_550 = a550[['wl_emission', 'emission']][2:].set_index('wl_emission').dropna()
atto550 = pd.concat([ab_550, em_550], axis=1)
a647N.columns = ['wl_absorption', 'absorption', 'none', 'wl_emission', 'emission']
ab_647N = a647N[['wl_absorption', 'absorption']][2:].set_index('wl_absorption').dropna()
em_647N = a647N[['wl_emission', 'emission']][2:].set_index('wl_emission').dropna()
atto647N = pd.concat([ab_647N, em_647N], axis=1)
In [7]:
atto550.absorption.plot(label='ATTO550 abs')
atto550.emission.dropna().plot(style='--', ax=plt.gca(), label='ATTO550 em')
atto647N.absorption.plot(ax=plt.gca(), label='ATTO647N abs')
atto647N.emission.dropna().plot(style='--', ax=plt.gca(), label='ATTO647N em')
plt.legend()
plt.title('Absorption and emission spectra (normalized)');
To obtain the absorption cross-section we need to normalize by the extinctyion coefficient:
In [8]:
atto550.absorption *= atto550_ext_coeff
atto647N.absorption *= atto647N_ext_coeff
In [9]:
atto550.absorption.plot(label='ATTO550 abs', style='b')
atto647N.absorption.plot(ax=plt.gca(), label='ATTO647N abs', style='r')
plt.legend(loc='best')
plt.title('Absorption cross-section');
In [10]:
atto550_abs532 = atto550.absorption.loc[532]
atto647N_abs532 = atto647N.absorption.loc[532]
atto550_abs532, atto647N_abs532
Out[10]:
In [11]:
ratio = atto647N_abs532 / atto550_abs532
ratio
Out[11]:
In [12]:
with open('../results/Dyes - ATT0647N-ATTO550 abs X-section ratio at 532nm.csv', 'w') as f:
f.write(str(ratio))